﻿CREATE TABLE [dbo].[DimCLM_837I]
(
[RecordID] [bigint] NULL,
[ActivityID] [nvarchar] (128) NULL,
[ReceiveClaim] [datetime] NULL,
[Claim_CLM02_TotalClaimCharge] [float] NULL,
[Claim_CLM01_PatientAccountNumber] [nvarchar] (100) NULL,
[Subscriber_NM109_SubscriberPrimaryIdentifier] [nvarchar] (100) NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[Payer_NM109_PayerIdentifier] [nvarchar] (100) NULL,
[CommunicationMethod] [nvarchar] (50) NULL,
[IsDependent] [nvarchar] (50) NULL,
[Patient_PAT01_IndividualRelationshipCode] [nvarchar] (50) NULL,
[RoutedTo] [nvarchar] (50) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL,
[Subscriber_NM104_SubscriberFirstName] [nvarchar] (50) NULL,
[Subscriber_NM105_SubscriberLastName] [nvarchar] (50) NULL,
[CLM_837I_ID_key] [int] NOT NULL IDENTITY(1, 1),
[Receive_UTC] [datetime] NULL,
[Receive_LocalTime] AS (dateadd(hour, -datediff(hour,getdate(),getutcdate()),[Receive_UTC])),
[InsertDate] [datetime] NULL
) ON [PRIMARY]


